<div class="editor-default-node4-header-medium" data-template="t_4_3">
	<img src="https://urc-thumb.oss-cn-beijing.aliyuncs.com/resource-temp/1725514076938section-ico4.png">1.3.6 使用Data
	Studio连接数据库
</div>
<p style="text-align:justify;">
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;作为一款配套openGauss数据库使用的客户端软件，辅助数据库开发人员便捷地构建应用程序，
	以图形化界面形式提供数据库关键特性，简化了openGauss 数据库的开发和管理。Data
	Studio允许数据库开发人员管理和创建数据库连接，执行SQL语句或SQL脚本，编辑和执行PL/SQL语句，导入和导出数据等。
</p>
<p>  <b>1. 安装JDK</b></p>
<p style="text-align:justify;">
	&nbsp; &nbsp; &nbsp; &nbsp;Data
	Studio是基于Java环境运行的openGauss数据库管理和开发工具，因此需要先安装Java开发环境（JDK），版本要求为8即可。此处以JDK8
	Update301为例说明安装过程。
</p>
<p class="p-fold">
	<span class="td-fold"><input id="check_1731597581761" type="checkbox"><span class="foldTitle "><b
				class="font_blue3 ">JDK的安装步骤</b></span><label for="check_1731597581761" class="check-in-fold" style="
        background-image: url('https://dbook.hep.com.cn/admin/css/img/upICO.png');
        background-repeat: no-repeat;
        background-color: initial;
        background-size: 30px;
      "></label><label for="check_1731597581761" class="check-out-fold" style="
        background-image: url('https://dbook.hep.com.cn/admin/css/img/downICO.png');
        background-repeat: no-repeat;
        background-color: initial;
        background-size: 30px;
      "></label><span class="element-fold "><span class=""><span
					style="font-family: 楷体">（1）双击JDK安装包，开始安装JDK，如轮播图1-3-2(a)所示。点击“下一步”；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（2）选择安装位置，如轮播图1-3-2(b)所示。此处保持默认，也可以根据个人习惯和磁盘空间状况更改安装位置。点击“下一步”。</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（3）点击“下一步”继续安装，选择Java安装位置，如轮播图1-3-2(c)所示。此处保持默认。继续点击“下一步”。</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（4）等待安装过程完毕，出现如轮播图1-3-2(d)的成功安装界面，至此JDK已经安装完成。</span></span></span></span>
</p>
<div class="swiper-container swiper-initialized swiper-horizontal swiper-pointer-events swiper-backface-hidden">
	<div class="swiper-wrapper" id="swiper-wrapper-15d16df2751a306c" aria-live="polite"
		style="transform: translate3d(0px, 0px, 0px);">
		<div class="swiper-slide swiper-slide-active" style="width: 688px;" role="group" aria-label="1 / 4"><img
				res-type="image" style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="P3FEGWJ8KJ"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=P3FEGWJ8KJ">
			<h6 class="tuIntro">(a) 开始安装JDK</h6>
		</div>
		<div class="swiper-slide swiper-slide-next" style="width: 688px;" role="group" aria-label="2 / 4"><img
				res-type="image" style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="FKBEUWC8KJ"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=FKBEUWC8KJ">
			<h6 class="tuIntro">(b) 选择JDK安装位置</h6>
		</div>
		<div class="swiper-slide" style="width: 688px;" role="group" aria-label="3 / 4"><img res-type="image"
				style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="PK4EGWJD3C"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=PK4EGWJD3C">
			<h6 class="tuIntro">(c) 选择Java安装位置</h6>
		</div>
		<div class="swiper-slide" style="width: 688px;" role="group" aria-label="4 / 4"><img res-type="image"
				style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="FKY2GWC83J"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=FKY2GWC83J">
			<h6 class="tuIntro">(d) JDK安装完成</h6>
		</div>
	</div>
	<div class="swiper-scrollbar" style="width: 100%;"></div>
	<div class="swiper-pagination swiper-pagination-clickable swiper-pagination-bullets swiper-pagination-horizontal">
		<span class="swiper-pagination-bullet swiper-pagination-bullet-active" tabindex="0" role="button"
			aria-label="Go to slide 1" aria-current="true"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 2"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 3"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 4"></span></div>
	<div class="swiper-button-prev swiper-button-disabled" tabindex="-1" role="button" aria-label="Previous slide"
		aria-controls="swiper-wrapper-15d16df2751a306c" aria-disabled="true"></div>
	<div class="swiper-button-next" tabindex="0" role="button" aria-label="Next slide"
		aria-controls="swiper-wrapper-15d16df2751a306c" aria-disabled="false"><br></div><span
		class="swiper-notification" aria-live="assertive" aria-atomic="true"></span>
</div>

<p style="text-align: center">轮播图1-3-2 安装JDK</p>

<p> <b>2. 使用Data Studio连接数据库</b></p>
<p class="p-fold">
	<span class="td-fold"><input id="check_1731591757628" type="checkbox"><span class="foldTitle "><b class=""><span
					class="font_blue3">使用Data Studio连接数据库</span></b></span><label for="check_1731591757628"
			class="check-in-fold" style="
        background-image: url('https://dbook.hep.com.cn/admin/css/img/upICO.png');
        background-repeat: no-repeat;
        background-color: initial;
        background-size: 30px;
      "></label><label for="check_1731591757628" class="check-out-fold" style="
        background-image: url('https://dbook.hep.com.cn/admin/css/img/downICO.png');
        background-repeat: no-repeat;
        background-color: initial;
        background-size: 30px;
      "></label><span class="element-fold "><span class=""><span
					style="font-family: 楷体">解压DataStudio_win_64.zip，进入解压后的Data Studio目录，双击Data
					Studio.exe即可打开Data Studio，在Data
					Studio工具启动后，会自动弹出“新建/选择数据库连接”界面。如轮播图1-3-3(a)所示。</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">&nbsp;在“新建/选择数据库连接”界面填写数据库连接参数，如轮播图1-3-3(b)所示。&nbsp;</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">“新建/选择数据库连接”界面的填写内容为：</span></span></span><span class="element-fold "><span
				class=""><span style="font-family: 楷体">（1）名称：自定义，此处为了方便区分，与“主机”保持一致；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（2）主机：根据实际填写安装有数据库服务器的IP，根据任务1.2的内容填写“192.168.108.138”；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（3）端口：根据实际填写数据库服务器的端口，根据任务1.2的内容填写“15400”；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（4）数据库：postgres（也可以填写openGauss上已有数据库）；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（5）用户名：创建的用户，根据任务1.3的内容填写“myroot”；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（6）密码：创建的用户密码，根据任务1.3的内容填写“myroot_123”；</span></span></span><span
			class="element-fold "><span class=""><span
					style="font-family: 楷体">（7）启用SSL：取消勾选，不启用。</span></span></span><span class="element-fold "><span
				class=""><span
					style="font-family: 楷体">设置完成后，点击“确定”按钮进行连接。对于未启用SSL的连接，会弹出“连接安全告警”，如轮播图1-3-3(c)。勾选“不再显示”，点击“继续”。</span></span></span>
		<span class="element-fold "><span class=""><span style="font-family: 楷体">连接成功后<span
						class="font_normal">&nbsp;</span>
					<kw res-type="keyWord" class="keyWord_e font_normal" id="kw_a_P3AW3YJFKJ">Data Studio主界面</kw><span
						class="font_normal">&nbsp;</span>如轮播图1-3-3(d)所示。
				</span></span></span></span>
</p>
<div class="swiper-container swiper-initialized swiper-horizontal swiper-pointer-events swiper-backface-hidden">
	<div class="swiper-wrapper" id="swiper-wrapper-39343924a66141052" aria-live="polite"
		style="transform: translate3d(0px, 0px, 0px);">
		<div class="swiper-slide swiper-slide-active" style="width: 688px;" role="group" aria-label="1 / 4"><img
				res-type="image" style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="P3RXVQJ83C"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=P3RXVQJ83C">
			<h6 class="tuIntro">(a) Data Studio启动界面</h6>
		</div>
		<div class="swiper-slide swiper-slide-next" style="width: 688px;" role="group" aria-label="2 / 4"><img
				res-type="image" style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="FK7XVQJD3J"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=FK7XVQJD3J">
			<h6 class="tuIntro">(b) “新建选择数据库连接”界面</h6>
		</div>
		<div class="swiper-slide" style="width: 688px;" role="group" aria-label="3 / 4"><img res-type="image"
				style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="P325TWCD3C"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=P325TWCD3C">
			<h6 class="tuIntro">(c) “连接安全告警”界面</h6>
		</div>
		<div class="swiper-slide" style="width: 688px;" role="group" aria-label="4 / 4"><img res-type="image"
				style="width:auto;max-width:100%;max-height:400px;" class=" cres" id="F3XQVQCD3C"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=F3XQVQCD3C">
			<h6 class="tuIntro">(d) Data Studio连接成功界面</h6>
		</div>
	</div>
	<div class="swiper-scrollbar" style="width: 100%;"></div>
	<div class="swiper-pagination swiper-pagination-clickable swiper-pagination-bullets swiper-pagination-horizontal">
		<span class="swiper-pagination-bullet swiper-pagination-bullet-active" tabindex="0" role="button"
			aria-label="Go to slide 1" aria-current="true"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 2"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 3"></span><span class="swiper-pagination-bullet" tabindex="0"
			role="button" aria-label="Go to slide 4"></span></div>
	<div class="swiper-button-prev swiper-button-disabled" tabindex="-1" role="button" aria-label="Previous slide"
		aria-controls="swiper-wrapper-39343924a66141052" aria-disabled="true"></div>
	<div class="swiper-button-next" tabindex="0" role="button" aria-label="Next slide"
		aria-controls="swiper-wrapper-39343924a66141052" aria-disabled="false"></div><span class="swiper-notification"
		aria-live="assertive" aria-atomic="true"></span>
</div>
<p class="p-fold"><span class="td-fold"></span>
</p>
<p style="text-align:center;">轮播图1-3-3 使用Data Studio连接数据库</p>


<p style="text-align:justify;">
	  Data Studio的用户手册可以在Data
	Studio的主菜单上点击“帮助”下的“用户手册”获取并查看。
</p>
<p style="text-align: center;" id="video_p_PK5MFLXKJC"><span class="td" id="video_td_span_PK5MFLXKJC"><input
			id="check_PK5MFLXKJC" type="checkbox" class="insertVideoCheck"><span class="videoTitlepc-new"
			id="video_title_span_PK5MFLXKJC"
			style="background: url(https://dbook.hep.com.cn/admin/css/img/vedio_pic.png) no-repeat 5px 7px;background-size: 45px;">视频1-3-4
			使用Data Studio连接数据库</span><label for="check_PK5MFLXKJC" class="check-in-new"
			style="background-image: url(&quot;https://dbook.hep.com.cn/admin/css/img/upICO.png&quot;); background-repeat: no-repeat; background-color: initial; background-size: 30px;"></label><label
			for="check_PK5MFLXKJC" class="check-out-new"
			style="background-image: url(&quot;https://dbook.hep.com.cn/admin/css/img/downICO.png&quot;); background-repeat: no-repeat; background-color: initial; background-size: 30px;"></label><span
			class="element-new"><video res-type="video" class="insertVideo cres" id="PK5MFLXKJC"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=PK5MFLXKJC" controls="" width="100%"
				poster="https://dbook.hep.com.cn/api/v2/resource/cover/preview?id=PK5MFLXKJC"></video><br><span
				class="insertVideoTitle" id="video_title_PK5MFLXKJC">视频1-3-4 使用Data Studio连接数据库</span></span></span></p>